The Development of Bill Claim Data Warehouse for Long-Term Care Insurance in Japan

Abstract

 Long-term care insurance (LTCI) introduced an electronic bill claim system since its beginning in 2000. Although the data derived from the system would have potentials to provide useful information for health policy research and decision making, the system suffers several structural limitations. In this study, we newly developed a LTCI data warehouse which had two layers to overcome current structural limitations. In the first layer based on a relational database, the latest claim data were chosen through queries. In the next layer, the data were further summarized for analyses. The developed data warehouse enabled to easily retrieve and merge of selective information items, and extended linkage with information from other database. Some examples were presented to show how this feature of the data warehouse helps descriptive and analytic evaluation of LTCI performance.